package com.hos.db.create.user;

/**
 * 系统信息
 * Created by guom on 2018/10/15.
 */
public class UserSysTable {
    public static String tableName = "user_sys";
    public static String tableId = "id";
    public static String tableSysId = "sys_id";// id
    public static String tableSysName = "sys_name";// 姓名
    public static String tableSysPhone = "sys_phone";// 手机号
    public static String tableSysAccount = "sys_account";// 账号
    public static String tableSysPwd = "sys_pwd";// 密码
    public static String tableSysNickname = "sys_nickname";// 昵称
    public static String tableSysPortrait = "sys_portrait";// 头像
    public static String tableSysRegisterTime = "sys_register_time";// 注册时间
    public static String tableSysBirthday = "sys_birthday";// 生日
    public static String tableSysSex = "sys_sex";// 性别
    public static String tableSysIdentityNumber = "sys_identity_number";//身份证
    public static String tableSysAddress = "sys_address";// 地址
    public static String tableSysPushId = "sys_pushid";//推送id
    public static String tableSysDevice = "sys_device";//设备
    public static String tableSysLoninTime = "sys_login_time";// 登录时间
    public static String tableSysToken = "sys_token";
    //状态 1：审核状态 2：审核通过状态
    public static String tableSysState = "sys_state";
    //
    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableId + "  int, "
            + tableSysId + " varchar(100), "
            + tableSysName + " varchar(100), "
            + tableSysPhone + " varchar(100), "
            + tableSysAccount + " varchar(100) primary key, "//主键
            + tableSysPwd + " varchar(100), "
            + tableSysNickname + " varchar(100), "
            + tableSysPortrait + " varchar(100), "
            + tableSysRegisterTime + " datetime, "
            + tableSysBirthday + " varchar(100), "
            + tableSysSex + " varchar(100), "
            + tableSysIdentityNumber + " varchar(100), "
            + tableSysAddress + " varchar(100), "
            + tableSysState + " int, "
            + tableSysPushId + " varchar(100), "
            + tableSysDevice + " varchar(100), "
            + tableSysToken + " varchar(100), "
            + tableSysLoninTime + " varchar(100) "
            + "); ";

}
